#! /usr/bin/env python
# -*- coding: utf-8 -*-

company_name = '福建优力特材料有限公司'
create_dept = '1820379858379681793'
obj_id = '1925814348980621313'
risk_unit_id = '1925841156643950594'
risk_safety_list_id = '1948663867041042434'
risk_level = 3


query_sql = '''
SELECT
    count(*) 
FROM
    hgyq_emergency.rp_m_risk_graded_control 
WHERE
    is_deleted = 0 
    AND risk_obj_id = "''' + risk_obj_id + '''" 
    AND risk_unit_id = "''' + risk_unit_id + '''"
    AND create_dept = "''' + create_dept + '''" 
    AND risk_safety_list_id = "''' + risk_safety_list_id + '''" 
    AND risk_level = ''' + str(risk_level) + ''' 
'''